

**********
*Table 3: Difference-in-difference estimates of treatment effect of Venezuelan refugee crisis
**********


*** Column 1 non BR 174 - Pacaraima 
clear all
set more off
cap log close
cd ""
use, replace 

keep treat1 treat3
rename treat1 pacaraima 

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria_vene post##pacaraima $x i.munic_code##i.year, cl(munic_code)
outreg2 using table3.1.1, replace stats(coef se) asterisk(coeff)

reg malaria_bra post##pacaraima $x i.munic_code##i.year, cl(munic_code)
outreg2 using table3.1.2, replace stats(coef se) asterisk(coeff)

*** Column 2 non BR 174 - Boa Vista
clear all
set more off
cap log close
cd ""
use, replace 

keep treat2 treat4
rename treat4 boa 

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria_vene post##boa $x i.munic_code##i.year, cl(munic_code)
outreg2 using table3.2.1, replace stats(coef se) asterisk(coeff)

reg malaria_bra post##boa $x i.munic_code##i.year, cl(munic_code)
outreg2 using table3.2.1, replace stats(coef se) asterisk(coeff)


*** Column 3 non BR 174 - BR 174 

clear all
set more off
cap log close
cd ""
use, replace 

keep treat2 treat3
rename treat3 BR 

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria_vene post##BR $x i.munic_code##i.year, cl(munic_code)
outreg2 using table3.3.1, replace stats(coef se) asterisk(coeff)

reg malaria_bra post##BR $x i.munic_code##i.year, cl(munic_code)
outreg2 using table3.3.2, replace stats(coef se) asterisk(coeff)